package jp.hoge.RSSReader;

import android.content.Context;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;

public class RSSReaderSQLHelper extends SQLiteOpenHelper {
	public static final int DB_SIZE_MAX = 10;
	public static final String DB_NAME = "DB_OESF_RSS";
	public static final String TABLE_NAME = "OESF_RSS_TABLE";

	
	public RSSReaderSQLHelper(Context context) {
		// データベースを作成する
		super(context, DB_NAME, null, 1);
	}

	@Override
	public void onCreate(SQLiteDatabase arg0) {
		// create tableの実行
		arg0.execSQL("CREATE TABLE OESF_RSS_TABLE(_id INTEGER PRIMARY KEY AUTOINCREMENT, title TEXT not null, link TEXT not null, date TEXT not null, description TEXT not null, last_build_date TEXT not null, rss_add_date TEXT not null );");
	}

	@Override
	public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
		// TODO Auto-generated method stub
		// do nothing
	}

}
